CREATE TYPE [SSB].[ssbIncomeType] AS TABLE
(
[Fund] [varchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
[FundName] [varchar] (100) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[AccountNumber] [decimal] (38, 10) NULL,
[SubAccountNumber] [varchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[AccountName] [varchar] (100) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
[Basis] [varchar] (100) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[ReportDateStartingBalance] [decimal] (38, 10) NULL,
[ReportDateCredits] [decimal] (38, 10) NULL,
[ReportDateDebits] [decimal] (38, 10) NULL,
[ReportDateNetAmount] [decimal] (38, 10) NULL,
[EndingLedgerBalance] [decimal] (38, 10) NULL,
[EndingLedgerBalanceDBCRInd] [varchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[FinancialCurrencyName] [varchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[FinancialStatementCurrency] [varchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[LocalCurrencyCode] [varchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
[LocalCurrencyName] [varchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[BaseCurrencyCode] [varchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[BaseCurrencyName] [varchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[MultiCurrencyFlag] [varchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[PeriodEndDate] [date] NOT NULL,
[PeriodStartDate] [date] NULL,
[PostingPeriod] [varchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[RealMemoIndicator] [varchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL
)
GO
